﻿  USING TianshuiProjectManagement
  GO

  ---更新数据字典
  UPDATE [Dictionay] SET [DictionayName] = '响应等级字典', [Memo] = '响应等级字典' WHERE [DictionayID] = 12
  ---新增数据字典
  DELETE [Dictionay] WHERE [DictionayID] = 14
  INSERT INTO [Dictionay] VALUES( 14, '公路服务与保畅预警等级字典', '公路服务与保畅预警等级字典' )

  ---更新预警表
  ALTER TABLE dbo.EmergencyReaction ADD AlarmLevel nvarchar(40) NULL